| Year | Month | DayofMonth | DayOfWeek | DepTime | CRSDepTime | ArrTime | CRSArrTime | UniqueCarrier | FlightNum | TailNum | ActualElapsedTime | CRSElapsedTime | AirTime | ArrDelay | DepDelay | Origin | Dest | Distance | TaxiIn | TaxiOut | Cancelled | CancellationCode | Diverted | CarrierDelay | WeatherDelay | NASDelay | SecurityDelay | LateAircraftDelay | date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1987 | 10 | 14 | 3 | 741 | 730 | 912 | 849 | PS | 1451 | NA | 91 | 79 | NA | 23 | 11 | SAN | SFO | 447 | NA | NA | 0 | NA | 0 | NA | NA | NA | NA | NA | 1987-10-14 |
| 1987 | 10 | 15 | 4 | 729 | 730 | 903 | 849 | PS | 1451 | NA | 94 | 79 | NA | 14 | -1 | SAN | SFO | 447 | NA | NA | 0 | NA | 0 | NA | NA | NA | NA | NA | 1987-10-15 |
| 1987 | 10 | 17 | 6 | 741 | 730 | 918 | 849 | PS | 1451 | NA | 97 | 79 | NA | 29 | 11 | SAN | SFO | 447 | NA | NA | 0 | NA | 0 | NA | NA | NA | NA | NA | 1987-10-17 |
| DATE | AWND | PGTM | PRCP | SNOW | SNWD | TAVG | TMAX | TMIN | TSUN |
|---|---|---|---|---|---|---|---|---|---|
| 2005-01-01 | 3.58 | 1351 | 0 | 0 | 0 | 57 | 69 | 45 | 0 |
| 2005-01-02 | 3.58 | 1243 | 0 | 0 | 0 | 58 | 68 | 48 | 0 |
| 2005-01-03 | 3.36 | 1542 | 0 | 0 | 0 | 58 | 68 | 48 | 0 |
AWND - Average wind speed
PGTM - Peak gust time
PRCP - Precipitation
SNOW - Snowfall
SNWD - Snow depth
TAVG - Average temperature
TMAX - Maximum temperature
TMIN - Minimum temperature
TSUN - Sunshine duration
| airport | totalFLights | averageWeatherDelay |
|---|---|---|
| “John F Kennedy Intl” | 338686 | 1.6215 |
| “Dallas-Fort Worth International” | 906186 | 1.5088 |
| “William B Hartsfield-Atlanta Intl” | 1255500 | 1.4402 |
| city | totalFlights | averageWeatherDelay |
|---|---|---|
| “Macon” | 3047 | 6.4247 |
| “Baton Rouge” | 6930 | 5.1538 |
| NA | 1202 | 5.1514 |
| date | totalFlights | cancelled | ArrDelay | DepDelay | TaxiIn | TaxiOut | WeatherDelay | A_AWND | A_PGTM | A_PRCP | A_TAVG | A_TMAX | A_TMIN | B_AWND | B_PGTM | B_PRCP | B_TAVG | B_TMAX | B_TMIN |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2005-01-01 | 4 | 0 | -4.5000 | 6.2500 | 6.2500 | 13.0000 | 0 | 2.013333 | 1398.667 | 0 | 55.3333 | 68.25 | 40.25 | 10.07 | 1010 | 0.0128571 | 68 | 71.0000 | 58.0000 |
| 2005-01-02 | 6 | 0 | 8.6667 | 15.1667 | 4.8333 | 17.5000 | 0 | 2.086667 | 1304.000 | 0 | 56.6667 | 69.50 | 43.00 | 7.61 | 938 | 0.0050000 | 69 | 73.6667 | 62.0000 |
| 2005-01-03 | 6 | 0 | -0.5000 | 9.3333 | 7.3333 | 14.1667 | 0 | 2.313333 | 1587.333 | 0 | 56.0000 | 68.25 | 44.00 | 8.50 | 1247 | 0.0014286 | 69 | 74.6667 | 62.3333 |
Dla każdego dnia w roku 2005-2007 wyliczana jest średnia/suma wartość dla każdej kolumny.
Kolumny z literą A -> Atlanta, B-> Baton Rouge
| date | Flights | Cancelled | Distance | ArrDelay | DepDelay | TaxiOut | TaxiIn | WeatherDelay | AWND | PGTM | PRCP | SNOW | SNWD | TMAX | TMIN | TSUN |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2005-01-17 | 6900 | 90 | 621.4017 | 7.1148 | 9.1040 | 19.1748 | 20.8896 | 0.1087 | 12.750000 | 34.0000 | 0 | 0 | 0 | 42.75 | 20.50 | 0 |
| 2005-01-18 | 6864 | 108 | 624.5524 | 0.4653 | 5.7185 | 16.3925 | 19.6530 | 0.0166 | 4.846667 | 208.3333 | 0 | 0 | 0 | 40.00 | 19.25 | 0 |
| 2005-01-19 | 6894 | 84 | 624.4482 | 10.7910 | 12.1278 | 18.3751 | 26.1941 | 1.1375 | 5.966667 | 1294.3333 | 0 | 0 | 0 | 43.00 | 22.00 | 0 |
| 2005-01-20 | 6894 | 132 | 623.4604 | 4.5400 | 5.6610 | 18.4769 | 26.0914 | 0.7955 | 7.310000 | 1346.0000 | 0 | 0 | 0 | 55.00 | 28.75 | 0 |
| 2005-01-21 | 6924 | 108 | 624.6924 | 6.2014 | 6.8292 | 19.4125 | 23.3596 | 0.2496 | 4.623333 | 2181.3333 | 0 | 0 | 0 | 65.75 | 34.75 | 0 |
| UniqueCarrierCode | Description | NumSecurityProblems | AvgNumPlanes | PercOfSecurityProblems | NumSecProbPerPlane |
|---|---|---|---|---|---|
| B6 | JetBlue Airways | 2465 | 104.0 | 5.9 | 23.70 |
| AS | Alaska Airlines Inc. | 2566 | 116.7 | 6.1 | 21.99 |
| WN | Southwest Airlines Co. | 11193 | 555.2 | 26.8 | 20.16 |
| XE | Expressjet Airlines Inc. | 4921 | 261.7 | 11.8 | 18.80 |
| CO | Continental Air Lines Inc. | 4613 | 358.3 | 11.0 | 12.87 |
| TZ | ATA Airlines d/b/a ATA | 581 | 55.8 | 1.4 | 10.41 |
| OO | Skywest Airlines Inc. | 2537 | 247.3 | 6.1 | 10.26 |
| HP | America West Airlines Inc. | 1235 | 149.3 | 3.0 | 8.27 |
| HA | Hawaiian Airlines Inc. | 233 | 28.2 | 0.6 | 8.26 |
| NW | Northwest Airlines Inc. | 2335 | 378.3 | 5.6 | 6.17 |
| Year | UniqueCarrierCode | Description | CollectiveCarrierDelay | NumPlanesThisYear | DelayPerPlane |
|---|---|---|---|---|---|
| 2003 | AA | American Airlines Inc. | 20511.03 | 912 | 22.49 |
| 2003 | AS | Alaska Airlines Inc. | 4959.60 | 114 | 43.51 |
| 2003 | B6 | JetBlue Airways | 1577.42 | 55 | 28.68 |
| 2003 | CO | Continental Air Lines Inc. | 4839.45 | 366 | 13.22 |
| 2003 | DH | Independence Air | 9659.87 | 150 | 64.40 |
https://www.statista.com/statistics/194941/customer-satisfaction-with-us-airlines-since-1995/
| Year | Description | SatisfactionIndex |
|---|---|---|
| 2003 | Southwest Airlines Co. | 75 |
| 2003 | Delta Air Lines Inc. | 67 |
| 2003 | United Air Lines Inc. | 63 |
| 2003 | American Airlines Inc. | 67 |
| 2004 | Southwest Airlines Co. | 73 |
| 2004 | Delta Air Lines Inc. | 67 |
| 2004 | United Air Lines Inc. | 64 |
| 2004 | American Airlines Inc. | 66 |
| 2005 | Southwest Airlines Co. | 74 |
| 2005 | Delta Air Lines Inc. | 65 |
| 2005 | United Air Lines Inc. | 61 |
| 2005 | American Airlines Inc. | 64 |
| 2006 | Southwest Airlines Co. | 74 |
| 2006 | Delta Air Lines Inc. | 64 |
| 2006 | United Air Lines Inc. | 63 |
| 2006 | American Airlines Inc. | 62 |
| 2007 | Southwest Airlines Co. | 76 |
| 2007 | Delta Air Lines Inc. | 59 |
| 2007 | United Air Lines Inc. | 56 |
| 2007 | American Airlines Inc. | 60 |
| 2008 | Southwest Airlines Co. | 79 |
| 2008 | Delta Air Lines Inc. | 60 |
| 2008 | United Air Lines Inc. | 56 |
| 2008 | American Airlines Inc. | 62 |
| Description | tailnum | AvgDepDelay |
|---|---|---|
| American Airlines Inc. | N428AA | 13.5340 |
| Aloha Airlines Inc. | N843AL | 2.6851 |
| Alaska Airlines Inc. | N626AA | 9.1925 |
| JetBlue Airways | N706JB | 10.4615 |
| Continental Air Lines Inc. | N77066 | 10.3207 |
| Independence Air | N693BR | 22.7075 |
| Delta Air Lines Inc. | N37342 | 1.1620 |
| Atlantic Southeast Airlines | N912EV | 2.0000 |
| Frontier Airlines Inc. | N804FR | 12.0305 |
| AirTran Airways Corporation | N344AT | 14.4200 |
| Description | tailnum | AvgDepDelay | type | manufacturer | issue_date | model | status | aircraft_type | engine_type | year |
|---|---|---|---|---|---|---|---|---|---|---|
| Delta Air Lines Inc. | N37342 | 1.1620 | Corporation | BOMBARDIER INC | 12/29/2000 | CL-600-2B19 | Valid | Fixed Wing Multi-Engine | Turbo-Fan | 1999 |
| Atlantic Southeast Airlines | N912EV | 2.0000 | Corporation | BOMBARDIER INC | 12/20/2002 | CL-600-2B19 | Valid | Fixed Wing Multi-Engine | Turbo-Fan | 2002 |
| Aloha Airlines Inc. | N843AL | 2.6851 | Corporation | BOEING | 07/08/2008 | 737-236 | Valid | Fixed Wing Multi-Engine | Turbo-Jet | 1985 |
| Description | tailnum | AvgCatchUpTime | type | manufacturer | issue_date | model | status | aircraft_type | engine_type | year |
|---|---|---|---|---|---|---|---|---|---|---|
| Delta Air Lines Inc. | N705TW | 10.3125 | Corporation | BOEING | 07/30/1998 | 757-231 | Valid | Fixed Wing Multi-Engine | Turbo-Fan | 1997 |
| Northwest Airlines Inc. | N626AA | 8.4138 | Corporation | BOEING | 09/05/1990 | 757-223 | Valid | Fixed Wing Multi-Engine | Turbo-Fan | 1990 |
| US Airways Inc. | N909AW | 7.7275 | Corporation | BOEING | 08/23/1999 | 757-2G7 | Valid | Fixed Wing Multi-Engine | Turbo-Jet | 1989 |